Main
Julian Collins
I have a twenty year career as a data professional, working with official financial statistics and latterly healthcare data. Most recently I designed and developed a data warehouse of linked healthcare data for 250k patients.
My expertise lies in uncovering meaning in data - to drive forward quality improvements and to tell stories
Currently looking for a position in healthcare analystics that allows me to exploit and develop my skills in R, data development, statistical analysis and visualisation.
Industry Experience
Data Manager
King’s Health Partners AHSN
London, UK
2019 - 2014
- Designed and developed a data warehouse for diabetes care within the King’s Health Partners (AHSN) Institutue for Diabetes, Endocrinology and Obesity, linking patient-level data from more than twenty data sources, drawn from GSTT and KCH Foundation Trusts, Primary Care, Community Services and public sources. This pseudonymised data covered 250k people, with tens of millions of observations.
- Using data pipeline SQL Server > R > Rmardkdown, produced a wide range of data and reports relating to the healthcare and outcomes of people with diabetes, including:
- cohort studies investigating renal disease progression; ethnic variation in eye complications; diabetes outcomes in patients with prostate cancer
- population studies highlighting variation in care and outcomes linked to deprivation/ethnicity/age, co-morbidities and service usage
- audits into clinical services, medication reviews, NICE guidelines compliance
- compiled National Diabetes Audit return for GSTT, enabling the trust to participate for the first time and successfully bringing together multiple sources to provide a detailed data picture that highlighted the excellent outcomes being delivered to Type 1 patients.
- Collaborated with/presented to external, including international, partners of the AHSN (pharmaceutical and medical device companies, AI data consultants) highlighting the data warehouse outputs.
Data Analyst
GSTT NHS Foundation Trust
London, UK
2014 - 2012
- The Diabetes Modernisation Initiative was a multi-year programme which brought together acute trusts, primary care, CCGs, community services and patient groups to improve health outcomes and services for people with diabetes in Lambeth and Southwark.
- Worked with programme leads to design a range of dashboards that monitored monthly progress against projects goals and KPIs. Designed bespoke monthly programme storyboard that focussed on current priorities, highlighting areas for discussion, and items of particular success or concern.
- A GP practice scorecard was used toward the end of the programme to drive continuous progress against patient outcome targets. Practices were aware of their overall position in comparison to peers and were also supplied with unique targets modelled against specific patient lists. This approach was extremely successful in both achieving GP buy-in and improving patient outcomes.
Sector Statistician
Office for National Statistics
London, UK
2010 - 2009
- Led a team of analysts compiling and publishing statistics relating to corporate activity on a quarterly and annual basis. Main outputs were sectoral data for quarterly/annual GDP and quarterly profitability publication.
- In addition to technical tasks relating to data compilation and consistency checking, this role required a range of research and analytical work to be conducted in order to understand trends at sector, sub-sector and business levels. Research activities would include working with the Business Survey teams to understand sampling frames and company response rates; confronting survey data with a range of other sources; analysing published corporate accounts; monitoring trade press.
- Explained data movements to a range of users, including national financial journalists (e.g. FT, BBC, Guardian) and discussing with expert customers such as Bank of England Monetary Policy Committee members.
Publications Manager
Office for National Statistics
London, UK
2008 - 2007
- Led a team compiling regional and local breakdowns of GVA and Household Income. These data were used to calculate UK structural funds allocations from the EU
Statistical Analyst
Office for National Statistics
London, UK
2007 - 2001
- Data compilation and analysis for UK Balance of Payments
- I represented the UK and a joint EU/ECB task force investigating data coherence and consistency across data frameworks and member states.
Education
MA Hons Geography 2:1
University of St.Andrews
Fife, UK
1998 - 1994
- sub-honours studies in psychology, social anthropology and mediaeval history
Other Data Science
TidyTuesday’ data visualisation challenge
https://nsgrantham.shinyapps.io/tidytuesdayrocks/
N/A
2020 - 2019
- Twitter community participating in weekly data visualisation challenge.
Selected Publications and Posters
Screening for co-existing thyroid and coeliac disease in type 1 diabetes. An audit of practice against updated NICE guidelines.
Abstract
N/A
2019
- co-author
Economic impact and associations of recurrent diabetic ketoacidosis in type 1 diabetes
Conference Paper
N/A
2015
- co-author